Seward County Community College/Area Technical School
Course Syllabus

1. TITLE OF COURSE: BT1063 - Computer Based Spreadsheets
2. COURSE DESCRIPTION: 3 Credit Hour Lecture Course. A course designed to acquaint the student with computer-based spreadsheets as used with microcomputers. This program is structured to be used as a tool for solving everyday financial or business problems for all types of businesses. For each unit of credit, a minimum of three hours per week with one of the hours for class and two hours for studying/preparation outside of class is expected.
3. DIVISION/DEPT/PROGRAM MISSION STATEMENT:The CIS Program will provide superior learning opportunities in the area of information technology, utilizing state-of-the-art technology, for both CIS majors and non CIS majors to enable all students to achieve their career and/or educational goals.
4. TEXTBOOK AND MATERIALS:
   • Textbook selected when course is offered.
5. SCCC OUTCOMES: Students who successfully complete this course will demonstrate the ability to do the following SCCC Outcomes:
   • Outcome #1 – Read with comprehension, be critical of what they read, and apply knowledge gained to real life situations.
   • Outcome # 5 – Demonstrate the ability to think critically by gathering facts, generating insights, analyzing data, and evaluating information.
   • Outcome # 6 - Utilize current technology relevant to their respective disciplines.
   • Outcome #9 – Exhibit workplace skills that include respect for others, teamwork competence, attendance/punctuality, decision making, conflict resolution, truthfulness/honesty, positive attitude, judgment, and responsibility.
6. GENERAL COURSE OUTCOMES/COMPETENCIES:Upon completion of the Computer Based Spreadsheets course with 80% or higher mastery of course competencies, the student should be able to:
   • Perform basic spreadsheet activities using spreadsheet software
   • Utilize advanced functions of spreadsheet software to create charts, reports, analyze data, and perform what-if data scenarios
7. TOPICAL COURSE OUTLINE:
   • Getting Started with Excel
   • Building and Editing Worksheets
   • Formatting a Worksheets
   • Working with Charts
   • Working with Formulas and Functions
   • Managing Workbooks and Preparing Them for the Web
   • Automating Worksheet Tasks
   • Using Lists
   • Analyzing List Data
   • Enhancing Charts and Worksheets
   • Using What-if Analysis
   • Analyzing Data with Pivot Tables
   • Exchanging Data with Other Programs
   • Sharing Excel Files and Incorporating Web Information
   • Customizing Excel and Advanced Worksheet Management
   • Programming with Excel
8. INSTRUCTIONAL METHODS:
   • Lectures, examples, presentations.
   • Hands-on student exercises and projects covering individual units.
   • Related readings and reports from computer magazines, Internet and other media.
   • Instructors will enforce the Academic Honor Code & Cheating Policy as set forth in the SCCC College Catalog. Students who fail to adhere to this policy will receive an F for the course final grade unless otherwise stated in the instructor’s course policies.
9. INSTRUCTIONAL AND RESOURCE MATERIALS:
   • http://www.microsoft.com/excel
   • http://cis.sccc.net
10. METHODS OF ASSESSMENT:
    • Development of both oral and written reports and computerized presentations on topics in information technology will assess student ability to gather and evaluate current information in their respective disciplines.
    • Hands-on lab assignments and examinations in spreadsheet applications will assess student basic knowledge of this software.
    • Research assignments/projects completed via the Internet will develop the necessary skills for students to search and evaluate information effectively.
    • Delivery of assignments from the instructor AND the student via e-mail will further enhance knowledge and use of this technology.
    • Note: The above mentioned course assessment tools will assess student knowledge of technology in a variety of disciplines addressing both the SCCC Outcomes and General Course Outcomes/Competencies identified above.
11. ADA STATEMENT
    • If you believe that you are entitled to special accommodations under the Americans with Disabilities Act, please contact the Dean of Student Services at 620-417-1016 or visit the office located in the Hobble Academic Building.    
    
    (Revised 11/10)